Syllabus

1 Introduction to Power BI

2 Connecting to Data Sources

  • Supported Data Sources in Power BI
  • Importing Data from Excel, SQL Server, and Online Services
  • Data Transformation with Power Query Editor
  • Data Cleaning and Shaping Techniques

3 Data Modeling and Relationships

  • Introduction to Data Modeling in Power BI
  • Creating Relationships between Tables
  • Understanding Star and Snowflake Schemas
  • Optimizing Data Models for Performance

4 DAX for Power BI

  • Introduction to DAX and its Importance
  • Creating Calculated Columns and Measures
  • Aggregation, Filters, and Time Intelligence Functions
  • Common DAX Functions and Best Practices

5 Creating Interactive Visualizations

  • Introduction to Power BI Visuals
  • Working with Bar Charts, Line Charts, Pie Charts, and Tables
  • Advanced Visuals: Maps, KPI Indicators, and Cards
  • Customizing Visuals with Formatting and Themes